SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 723412 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 723412 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836017,384443,275189,918046,161521,919415,463903,604725,802975,228290,225629,383665,394423,247651,137907,227878,486689,93567,375639,86386,453603,535217,297050,1017804,1033562,525775,655899,138223,635804,551088,830745,115506,695448,560918,184527,1013659,762635,380071,858198,718260,176351,21710,1046702,704629,313471,294925,318140,501760,36252,120071,406223,498139,28135,300080,412649,399985,295354,382620,1012149,308069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 723412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 723412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]