SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426410 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426410 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979320,834716,415857,727768,984315,752659,864048,630831,611106,515350,503548,166474,386808,487045,1022888,109678,553290,278920,91542,75159,168942,250181,563081,588179,1007748,918684,204053,148299,795202,347772,421233,758429,234676,318774,34802,40446,1026242,98085,923318,329031,771464,1014501,462593,996139,340616,302143,363765,1012271,372180,700588,487228,531382,689278,479055,438172,1031031,595322,611111,952968,642384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]