SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475662 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475662 [ RunTime:0.004352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13090,223152,1031642,248082,500667,961001,572410,358902,67654,531763,411644,444174,1001999,837991,65769,503533,673743,351120,720411,1019777,235924,319122,617665,809455,578566,393163,28075,634953,350087,1011087,392906,336717,153205,945926,790131,502142,395474,265269,133293,164030,234472,587167,1048893,259391,348289,658980,841177,324953,713249,1024930,388335,883544,431763,693280,505287,30454,739894,535407,207553,807572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]