SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305310 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305310 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796715,713771,138075,330496,79868,918409,988242,399813,207418,891618,869182,765704,776119,330685,838878,343535,730328,1020259,914304,961303,428174,513891,755536,695943,514213,761217,1200,411169,851327,1033732,539395,266426,248516,913383,82064,299275,72634,582363,635243,533640,576290,739323,396522,587746,777479,517826,94487,75468,204282,760837,35620,233240,969177,752719,549846,462768,994563,431229,1034073,862113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]