SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571184 LIMIT 1 [ RunTime:0.003380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571184 [ RunTime:0.003220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040215,3310,333271,690753,781887,686377,711667,404980,967411,298690,259231,1004953,1042204,1018045,418607,855154,108023,41095,282487,696784,182928,997699,83969,889830,5334,543725,484821,338310,642225,539354,473347,1012014,248700,125540,854046,376515,33690,65559,850837,799928,404153,508616,332518,912603,139642,184572,530765,806538,657468,206614,953439,679120,576716,714780,1037060,751249,453687,748100,28293,467084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]