SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031834 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031834 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244491,467920,394667,290125,41664,1031534,158083,208766,205309,954195,873451,1032036,403118,721972,784814,810449,844659,522611,583488,1042992,731787,661115,996143,402202,1041414,440837,731433,182800,814126,307965,1000061,870556,468168,261865,1044584,129291,1004391,334983,407569,870788,469131,788856,426329,150225,34263,696640,355121,219338,1029192,258314,917957,790207,745261,491023,558571,331774,291752,243048,288511,268605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]