SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392530 LIMIT 1 [ RunTime:0.001160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392530 [ RunTime:0.004087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511220,513453,126753,435309,6457,34915,390414,180492,187540,578499,404847,367864,768859,383017,522701,34053,1047621,401869,421521,214230,844365,264285,235610,511013,122803,331089,666329,817525,541900,344536,216925,495269,172436,567120,573774,388172,20761,685456,445514,660445,36310,604921,327687,60335,420710,339523,481522,867149,1034976,741965,830397,612374,57880,285662,523999,282265,855517,396591,386512,400325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]