SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319821 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319821 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716562,66554,840749,301784,1031601,480889,33752,1018374,520579,83102,502648,850689,868882,922190,95787,957102,96018,471317,1030929,451800,209380,411314,3347,688686,203404,1042027,305841,539248,41049,1042148,635399,724480,584110,118019,754047,369096,322504,437838,316946,496882,249742,187139,511080,87661,400032,155305,26682,419023,817440,93790,572477,501077,46982,377009,773953,392705,319777,750956,561606,569245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]