SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457907 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457907 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355553,880328,63525,521135,769606,134766,1027055,484060,851318,853242,740476,478149,856942,83712,402667,32202,525847,635736,793835,400188,736237,334578,890646,42488,968918,992049,766091,139321,202131,274547,705003,893498,384285,988354,685238,812463,584369,187552,526153,289160,725055,157568,425245,482097,512258,246247,498113,1003406,794623,295980,251755,798255,421265,34186,656244,1020502,948516,577816,765097,983240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]