SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106104 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106104 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679599,975104,86552,281495,700372,420201,753083,72718,1047036,878340,794400,515639,139871,207984,980403,529771,464062,684438,724867,559715,338086,727822,105368,204927,594706,727184,487943,496540,584112,1007964,101122,875344,971761,76417,910143,796723,336191,98157,246196,212919,861525,2216,744267,768740,1007546,557642,447286,192447,365376,969396,104519,556248,276203,226875,499047,39897,40542,1000841,838356,345817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]