SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403610 LIMIT 1 [ RunTime:0.003043s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403610 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266128,649645,352114,544610,201130,544879,908995,533842,413829,868613,76292,267971,87766,570991,620959,873352,154470,592491,978442,706994,433829,575836,460779,386750,647027,846919,889967,880838,238874,775258,452411,182123,139992,872263,856526,808548,948213,769440,664287,186174,53099,252217,388424,98244,126572,1019240,929303,828664,112130,848976,420857,273512,790003,46126,896472,493098,123528,87405,893371,236771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]