SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803122 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803122 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285861,1002148,359826,603455,121249,1028184,912472,680438,105291,1006170,216172,519,644711,698101,616466,630463,567797,56979,926237,942550,718649,178103,875767,719075,610946,907055,28346,216781,982508,388017,138116,22284,934163,633184,258226,706582,433888,403733,118392,44505,605956,395684,925901,377061,433510,5620,752636,720974,712062,301233,194819,790139,739481,612750,423327,424256,244503,493098,869286,910424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]