SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961026 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961026 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46246,391049,39711,227559,471790,273488,38286,30132,353238,8063,662644,341222,971490,503911,714795,630313,378712,306743,359446,215637,172948,211389,777262,272758,658759,1026331,986987,858809,350818,543596,516000,90930,415525,117253,278119,482148,327368,520063,107538,504619,798193,25862,702669,395321,919734,576204,354076,75241,699836,970008,355651,653871,266326,546462,961172,254030,141698,670391,334903,357352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002071s ]