SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506713 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506713 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60155,312081,738291,347381,116637,237177,672578,167054,808974,423298,841851,384029,570793,807587,465099,401555,394376,661739,462899,1027722,772637,654893,157589,466707,329940,308301,51224,977185,461439,917046,723603,794289,120826,607783,209348,847412,391986,368136,257434,755752,11908,88910,278341,1017895,927737,272716,799190,430593,44248,9185,209765,345069,871912,459264,902570,47034,148518,824339,764288,207105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]