SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537628 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537628 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617685,757145,590339,362580,972051,30913,978028,406571,306322,278846,591014,62973,72475,634615,104487,430512,1032663,856912,414124,364138,616131,346441,594055,740286,170687,148748,381776,718881,272636,392967,922731,782893,484974,606748,244555,185088,217133,392205,792978,514386,335127,795695,156229,194178,698339,769054,689238,149728,1020429,400168,783708,670043,827566,204183,749941,702315,701582,941116,450458,1039633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]