SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423001 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423001 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280801,732572,291969,489479,382093,975077,125535,607177,827160,854873,590676,458031,559333,737713,514917,409512,801377,168230,340055,291467,312891,899618,867221,424903,5579,857091,1006609,894998,486599,110063,380451,147877,755151,324948,485037,404884,281492,1468,869657,1044982,262409,115451,808258,441712,700072,803157,715475,133388,1022057,674532,362623,37900,120,775295,784313,473463,443707,898374,818188,673331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]