SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58199 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58199 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752229,437235,584082,500102,302401,268052,166186,734872,510801,550426,349647,328716,775607,797321,792035,536903,675028,855317,385251,374773,512502,599742,568912,823998,497860,1013128,369084,859307,953799,237190,572021,509713,1029301,532411,653908,1021097,619760,572956,821412,341206,896941,832874,391708,534662,794544,681690,663939,835121,240040,403914,561523,537215,1010560,640643,980251,37333,647986,323851,10083,72801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]