SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802243 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802243 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524642,173869,250791,30880,490891,378582,517349,412421,997060,974759,559695,464865,631192,514836,925575,1001852,260179,901217,92365,533181,475809,753963,31369,41909,908369,118054,120083,375653,667469,281639,634938,1010710,531965,189752,475744,205721,385550,227350,997776,31115,4736,200741,451304,553886,744407,528428,975539,359662,59333,551947,116885,409369,373233,920741,28992,745570,393353,325561,518271,296030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001169s ]