SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402197 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402197 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663925,1035947,121030,700743,931926,638212,393038,1012614,445204,710069,1043835,119020,868401,382249,486011,963866,606803,397082,1008504,898217,285332,533679,711864,882929,575174,461793,438132,438697,359108,123115,147861,170026,218807,823725,12417,399516,887943,464153,543141,687811,936498,682485,619617,609344,813538,905039,112566,718122,724388,867935,491525,105559,167242,263913,254595,616451,937380,24915,653686,909861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003375s ]