SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012454 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012454 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793922,154873,111409,381981,183102,448179,273733,225541,965389,609025,729656,836651,197081,53550,55921,387020,800720,547430,912347,560923,703142,867058,1018174,378715,1028323,85768,777414,57024,673797,595003,444268,530205,742789,918502,569808,501303,944557,677506,708323,865728,92894,13232,901519,895301,178586,13385,739874,658144,754223,1030191,883824,147113,225647,815461,585064,70892,119150,130987,85462,396060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]