SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405488 LIMIT 1 [ RunTime:0.001108s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405488 [ RunTime:0.003501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023351,911145,641242,551959,896553,938916,599196,411609,241502,815585,580821,535181,822338,746695,1009706,226428,471368,1032986,823891,672662,499237,368300,1044962,965557,964365,323281,872391,47324,655763,422157,790832,789743,139179,961082,73838,925051,254024,754620,467850,347443,196261,298506,662958,814044,282305,185087,750444,827520,224725,53976,427590,887976,5542,496271,808490,314775,668503,430492,575889,338772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]