SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30100 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30100 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251694,419852,477826,895192,224743,365916,257026,354402,832492,712963,1039053,227385,418199,965040,45029,596868,734547,265603,257158,520348,543544,460306,223413,541947,681338,410427,546933,980592,756673,65909,535190,814320,717141,413796,479520,753849,660485,493123,326530,798387,331359,233178,939444,79069,301,504641,850057,680818,10257,735158,606973,78797,253113,598841,554833,1022618,874428,336266,722805,62648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]