SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535970 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535970 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557811,1021732,632995,294701,520804,232487,486734,730380,526508,502021,23977,355010,710817,8047,73141,205513,912516,326854,527867,94062,373278,347472,484414,581675,291744,5211,180428,266586,317075,685332,149303,775605,780842,302702,154667,539823,378102,165818,324993,590933,355501,966510,613596,183041,639914,860080,930450,99577,713698,442763,269486,893449,242937,988724,202788,195255,420948,565024,187096,123789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002737s ]