SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282335 LIMIT 1 [ RunTime:0.000781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282335 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433087,443346,954236,463866,136402,905217,802784,972567,701219,210593,894696,670944,836062,506957,622027,647470,364843,551957,1016990,81487,501112,198899,485600,719761,525262,332681,561036,411758,931286,843249,839735,712040,765056,12432,504914,508178,602318,626094,580481,988235,663678,90670,981862,571825,803651,194291,855384,188311,680024,641816,176124,700106,994234,722285,541679,392998,586944,691489,49437,1026902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]