SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510630 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510630 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579163,595211,606307,105058,596346,168478,755239,180811,698887,451959,154880,448166,387031,839400,31362,187285,313949,920305,191432,174940,357591,247142,453573,818652,918511,300375,317138,302848,518617,792058,735616,294121,43556,779662,537579,204693,143650,921149,983734,782520,705480,366573,529790,526495,610719,451180,825149,777781,334342,421277,746185,431423,841161,285134,360022,278250,946002,13067,636,291743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]