SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223010 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223010 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808604,540133,141313,913414,260394,371611,497164,628693,227021,64941,716590,359392,1048454,816191,508917,381884,976631,586850,629706,254164,686833,160539,240018,556887,498298,379227,607517,315912,47149,409759,1014000,121709,691801,821134,537854,816817,765349,13853,42827,443788,670849,299124,821435,874573,986567,98043,61980,257305,530709,361181,992292,505134,3343,780242,220784,471679,594731,78677,196033,414113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]