SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567245 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567245 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533463,566764,747780,49371,565590,123423,899672,279220,665214,653055,370205,191067,575887,603863,112619,299713,871875,848218,274470,860465,981697,907699,299245,8429,447156,269925,758236,682025,753158,656142,857879,429456,26348,298855,836711,879535,109553,784462,175106,661965,48007,336827,453420,119599,159419,495805,423961,466836,449229,189847,979691,701297,399728,265090,814955,108717,870429,851591,195406,777722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]