SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004815 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004815 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344101,861168,258094,73027,204798,374263,891972,164227,757210,1043976,718598,915971,203386,984630,351040,100526,622451,877261,1007031,407812,147607,75705,613607,829968,224644,694674,918758,717791,651604,820763,18536,1028099,33936,402239,31393,275443,826051,940215,809134,636480,751832,458699,361828,449808,614407,269945,364188,774148,730489,1032542,670126,363100,835172,597154,844876,216465,1001290,417635,906646,567831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]