SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441931 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441931 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232346,873220,632692,38404,44690,699891,173597,67004,476840,1021581,318784,185895,560793,176155,306576,797915,75063,842676,995861,944413,168254,213416,388163,507148,352310,811710,147893,510766,69792,726256,256580,1046236,798372,855559,745709,691265,948787,434700,12309,1022175,792254,97394,118539,436938,814930,439896,780444,806279,1042721,161386,637508,229027,387356,24562,961914,519281,990829,379897,405331,49698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]