SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004871s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41343 LIMIT 1 [ RunTime:0.001034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41343 [ RunTime:0.005635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971775,82473,10287,598987,200668,87511,234044,372436,1029507,672524,411469,272611,514241,200758,869259,523836,373212,743841,874788,764903,90324,949899,918489,957994,198974,606781,217072,293917,1014112,651577,326737,62944,948891,505576,200339,209526,382820,417853,901125,412466,769901,750543,1062,541723,195465,874446,224797,138877,152182,741543,439975,940831,199300,439856,1048304,859155,725230,367543,532253,550551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]