SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341254 LIMIT 1 [ RunTime:0.002039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341254 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10405,329303,75648,632479,987024,68785,800607,638438,770193,296119,388114,796356,311841,944083,174866,467434,89980,858042,789021,568132,624488,1045849,26277,302854,789194,1039565,608609,249481,264058,777042,154140,236044,71869,374887,496306,1043840,325467,703759,349043,6708,442689,886513,241824,1035101,940624,18169,973268,462920,72907,713717,494588,276115,1029986,684470,548707,227132,823122,695833,766855,66841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]