SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042643 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042643 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666545,300974,639275,57186,209463,732968,931492,533033,532409,455776,118442,315434,349099,268611,166042,524474,751103,932815,1022603,796519,407006,285968,781565,887588,942040,789591,207520,829329,134296,448382,576506,112538,294121,1039132,328552,764048,1041483,417436,75005,898794,1002205,715359,849907,939039,699164,743090,438383,343840,917722,648782,73477,573648,653872,585138,572193,364047,648657,1045475,178104,929090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001020s ]