SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012814 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012814 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444275,148843,68031,778962,126340,934035,6965,956279,828033,537386,978730,627075,222269,596963,764855,853679,187099,467882,996159,952937,682809,106182,528087,511443,931801,774216,738185,898353,196832,752984,984569,328714,888546,22807,1021331,186726,279427,290677,503908,519486,810491,1035098,735568,251152,731141,1008246,146325,167821,807898,859140,298169,835029,954907,493037,229922,394011,285635,755451,613173,731763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]