SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045445 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045445 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844024,23480,1017538,871748,795535,792534,511371,832051,647505,1020699,127619,75350,861878,538829,31454,528174,395769,18788,224200,1117,950366,433407,577699,545303,633342,677873,840057,599412,526832,958175,923495,171681,988559,153474,281548,743936,858742,198349,778179,95672,94543,480200,307352,359541,845687,678615,1018095,651468,234423,378223,163606,876260,529372,459325,258511,757651,358629,450763,657366,716935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]