SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332716 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332716 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55951,620267,52566,1040478,461150,389022,315434,735442,193062,203564,316536,354639,806895,990596,1013902,469548,118073,441404,619636,737463,774695,67418,323885,787880,624479,350901,1007195,819512,138663,409670,896037,807177,350580,729811,200032,184076,493111,200335,30688,776390,163064,744738,158710,606018,452176,896463,746501,519662,967902,522976,245000,1012686,494789,929743,717904,252925,922949,115960,120903,795739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]