SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201361 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201361 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418255,627568,375976,941329,579551,673007,866148,683004,810504,952765,848927,538146,931612,5631,496036,590524,935863,1047292,37045,308673,661738,719001,427584,275272,618495,874284,403560,712724,112856,933607,235328,808594,193211,1031451,554098,342676,275742,738822,381059,322774,661160,58089,774665,371995,896559,712974,459051,510666,841531,880577,73131,650887,717815,178510,22086,527739,653848,244330,887081,713464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201361 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201361 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]