SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481526 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481526 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283962,869236,125146,802242,1023151,815155,738292,563274,68954,744110,981830,46332,87321,253242,245926,109216,715563,742452,235428,311697,183518,408213,250656,551591,175786,770560,801221,467045,236272,326937,377281,420738,925198,791319,730071,580645,808636,678060,1013446,980295,756054,44709,816828,697530,996010,564078,792446,492697,513450,1020361,172058,209065,667620,548482,248425,929926,624050,586048,933401,411164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003494s ]