SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405560 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405560 [ RunTime:0.001406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818943,123449,400453,641940,488246,658055,28994,956563,248252,698352,904538,81609,204614,976423,986101,615085,1001289,917266,174012,633901,504502,1019347,902948,730404,179931,397879,394239,531077,82163,431096,56794,876831,95230,492775,371251,995668,414758,522161,245563,648215,93688,1007315,243954,464519,899678,774873,674201,830686,424685,539206,942203,634537,416578,534592,118654,745820,457726,272159,323679,102420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]