SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920144 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920144 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940363,942542,528140,713019,636002,545795,111471,956204,196319,418218,764572,558407,615875,322885,486252,631034,280009,575464,751674,759558,573188,283722,667026,204465,106064,120571,557573,796759,208263,132856,743277,11177,359903,325079,778263,1048162,1003240,841924,742370,830541,291940,242885,805920,131628,32206,241681,146826,268294,10369,504939,56306,578101,485425,1040855,678226,814008,871813,913997,649400,870133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]