SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38461 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38461 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660186,159208,164270,313014,432251,395663,349472,729924,696865,100675,518979,928094,411847,307019,28515,512620,606335,1023113,730116,404646,788896,343601,257737,110962,108935,620634,65999,317638,641401,913233,965784,339054,306882,713794,380802,877054,899336,197958,313887,275765,798451,411052,1011076,829593,14299,901741,208728,1012238,993158,437074,59295,249220,609152,463834,369190,946590,836623,1034401,703129,580334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]