SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403328 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403328 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648714,909870,455639,361818,211039,734845,586317,123184,819579,301912,599198,797967,255520,258917,670093,16781,554181,766885,1043226,394746,32994,240769,454980,776533,812082,184807,581500,54763,932075,751956,778485,511825,587802,795244,1037321,764208,562634,317870,766063,696402,399094,608528,375359,115211,836898,1015418,712837,67603,805803,567319,515166,282198,52478,787033,250253,78552,627129,516718,37293,391800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000918s ]