SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36184 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36184 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225571,428985,300230,1027933,335284,124432,646839,877986,673450,1045803,727367,230031,387293,705247,801378,252111,743470,442514,706305,404011,90719,460909,1041490,59975,489388,571814,301628,643047,795892,705686,1001925,893807,147312,522535,142996,230867,323049,975052,296149,730111,193072,178155,281951,920432,242362,1016288,102754,213360,270048,1029075,1047842,211661,33496,222064,163961,812459,421068,255654,398062,296738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]