SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486528 LIMIT 1 [ RunTime:0.002460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486528 [ RunTime:0.003448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892022,323502,146507,748315,459893,717425,444698,604562,687714,818614,758384,1042110,291860,621775,19262,761397,9724,618692,527661,595994,500022,269518,649578,278244,590422,733627,830796,676301,35725,775393,656288,736429,922709,766989,6448,948142,826815,295859,750592,1002184,1018618,78209,155856,804885,966199,647033,580595,282552,226341,103669,123857,784307,42289,86918,512167,346664,523328,599993,827144,145694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]