SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920815 LIMIT 1 [ RunTime:0.002051s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920815 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504020,638804,676362,923449,351301,608680,699930,879714,336075,947636,979814,230311,564898,471812,772975,393144,844392,952867,323202,688330,181712,876677,674046,201109,232989,237840,758707,426744,521479,1014700,684483,825652,958002,503455,356381,546041,555016,638376,297330,388112,376220,675511,379059,943178,908214,669433,285228,842577,263042,935163,158473,961362,572619,123069,340150,169714,477382,501338,947111,644654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]