SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449470 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449470 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737771,10477,1016413,37617,309093,539213,752361,854971,809357,304775,975988,390687,792301,161598,158255,494537,1042946,977773,134038,650207,825338,73256,496901,969775,837586,41824,982502,747768,535131,449686,552328,277634,304377,1046325,792040,570169,699400,94944,501380,771567,193127,434345,1018592,773127,465441,677710,871007,369752,597311,329107,1040468,770449,124345,423263,780444,269970,484475,5437,829390,1048098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]