SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541534 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541534 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046286,732922,692365,711663,763899,133673,892907,353274,1023489,79052,803209,347920,859760,131162,648118,805828,1033422,437682,1019185,12612,847588,931579,55580,253680,836555,294195,8803,117313,142421,546997,433937,285863,570306,82688,289482,700851,626164,535252,414190,664023,689793,913960,169264,175116,159319,225179,124985,245023,1009974,96631,818152,591566,621265,62696,388715,552844,586014,961786,420833,797983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]