SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418552 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418552 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660104,862442,604819,773468,925021,510888,613592,579455,292174,203348,69711,991937,794853,465714,632232,518041,314088,496788,127778,971330,6951,687654,348521,848032,194303,718656,486274,707867,662441,119720,966267,415198,200519,425346,818799,789417,1018862,116496,252092,831095,27851,22905,966923,878897,729640,91725,899634,108416,798012,772753,745442,912291,759161,117073,416464,718606,713124,93334,689812,411837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007294s ]