SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425066 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425066 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005629,394763,461020,182380,197426,794472,110783,207059,650086,935414,589039,859953,481059,400827,20780,837809,174914,449000,273931,200841,942968,940868,837440,431248,521682,756081,695616,976607,465183,223162,45487,308485,260758,395638,554428,222626,436802,561417,956278,966787,124425,63426,105462,648798,1003695,1042949,521422,657210,128119,338292,32885,355030,401928,537293,301808,789920,224218,852848,12120,611925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]