SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523500 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523500 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37897,694936,134155,1045747,438054,23541,974897,688927,1022715,795452,4548,934042,693311,949394,888130,135346,291720,414989,640441,412807,397348,926418,69923,802127,835664,836436,393151,127937,138959,844335,965578,533816,635560,572611,694587,231595,165076,97624,469296,912940,463067,546834,1010905,816418,525976,547478,2076,409706,805924,419361,33636,86890,511289,59591,542488,627783,1014585,72383,893728,198970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]