SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285020 LIMIT 1 [ RunTime:0.001179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285020 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575968,10471,355903,798413,130004,1040610,265750,288650,676628,934490,638547,502485,698796,832399,1012460,888935,64230,682163,15890,1015838,686093,829434,80663,209805,493871,267055,1033780,938872,395145,128167,205247,764332,62601,1034606,511128,718187,979910,134068,469364,932421,93070,242686,678798,692842,820210,803012,820248,131385,16024,439086,768381,319734,939903,597652,965045,882777,815352,4128,1016908,859528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]