SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027651 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027651 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523867,417987,790494,548818,243037,405332,121572,325210,200277,113247,309428,512404,210547,561444,389687,853476,468828,619203,235849,617285,903524,858665,989906,510653,167927,405754,771200,92371,500967,815665,985267,699333,722276,14061,63033,545508,758309,36025,857963,697142,507215,149572,518989,4317,121828,422179,179651,688980,308607,138149,15632,115571,929262,627901,67661,90735,510131,615230,44386,338494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]