SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576649 LIMIT 1 [ RunTime:0.002666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576649 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325738,92509,317832,1005040,625799,767091,271925,980979,772358,896025,34729,642029,137885,270142,445006,43951,996634,322879,341182,723770,833798,284521,680719,12260,1034877,381090,854138,256714,534006,279619,466148,593864,747601,778923,289859,133686,269010,688136,496305,161814,650386,875800,831049,912391,969201,585588,189729,519790,537000,130187,451260,968088,687007,950403,455322,449938,85078,482477,532999,969590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]