SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047128 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047128 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415006,1029220,102378,664721,471556,566775,1017338,838405,563210,455155,591721,23962,96880,9800,68380,156035,526085,594045,700233,528076,910842,35334,674961,453411,973263,495222,782597,578599,116834,840427,567805,507300,341050,500179,856412,593350,595925,184458,617435,175803,348969,397467,108063,335078,706817,70184,1613,681668,953296,81338,858382,65555,402687,106379,466809,30636,761488,130789,28419,615795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]