SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412629 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412629 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666774,766739,132449,1045013,262120,260505,879266,993407,188588,960263,558343,47600,631751,852692,712570,489646,357357,112180,915880,826396,1029164,387620,213524,487670,736092,101798,610537,175132,80532,183043,770738,1018169,50954,857128,997270,193521,561443,157225,705213,935228,263792,943897,388003,62734,472423,234525,551855,47096,887274,923377,784850,868050,132456,3601,516377,187480,990687,406333,1549,109434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]