SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581413 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581413 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667155,418521,409176,403947,997650,655981,1007152,357793,328217,150424,772910,716060,758776,741961,375041,265225,594351,695771,473318,637915,351131,1042343,457188,964960,331661,54827,517156,744491,241368,1013156,974905,211169,736560,919847,839261,103014,479245,257917,168958,171976,612093,529050,327588,659792,721725,849182,736001,1039428,416755,1000778,34177,387758,288822,581202,966016,917771,875580,937464,1012464,486348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]