SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269483 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269483 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441232,984169,620851,717462,714008,1048294,422637,814207,666154,911421,143391,423098,730463,365119,405654,996582,107055,154316,613734,636781,16394,1026613,429661,74118,1002388,1034984,630380,261457,365743,804808,538490,322657,908475,455173,682741,551215,973601,199570,195223,136930,769229,627548,916318,340460,878207,881670,350400,220317,259406,718158,421469,913729,896860,641366,968251,206508,422123,557723,960101,331982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]