SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504713 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504713 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866521,406636,550137,575096,307277,799075,653222,871863,480635,87468,620283,387324,959788,1022705,516753,865767,616040,775629,561925,579557,76217,921608,226812,635446,746896,297732,102775,900917,353139,794697,261743,476193,329931,211593,619693,111746,655273,648867,383752,161778,568370,286796,495147,182414,1017463,731090,684933,116595,438192,346773,379349,831236,276816,1041796,1027369,526716,290855,921477,5759,705213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]