SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468201 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468201 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033612,457541,820711,1034338,957041,306384,549186,353480,901994,622604,948292,154127,849333,272231,983496,472044,902400,147185,896049,570434,656090,459309,81376,22450,906266,447638,500702,532461,179816,158704,162094,21243,751789,416965,922109,295014,7331,614238,572726,116178,70667,507006,484716,92604,17340,497783,733835,570367,661050,597775,1046859,138086,728630,682155,854307,401379,682042,719297,827581,900340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]