SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 990104 LIMIT 1 [ RunTime:0.005663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 990104 [ RunTime:0.011727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040813,415116,257665,561177,478167,880065,856439,1021914,390614,169057,251777,592836,182218,766684,406448,440390,131255,894102,1015413,376032,689805,518019,137190,109153,874217,965141,337316,392140,269507,1033164,574990,541211,692186,135943,533064,553004,827885,443674,189097,293347,251439,177399,416935,70670,438023,595388,908709,571305,912614,697226,996346,363236,97204,613324,223706,744307,642845,740432,694535,711587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 990104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 990104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001339s ]