SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34018 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34018 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198892,802083,201271,49735,990896,468607,295898,607845,96543,785311,839177,134941,972590,951389,351462,482247,474814,582269,547089,299709,1045622,969271,653332,34381,44696,311016,196563,233545,206360,1009004,875818,22200,670952,705663,905964,110493,959404,342029,853008,60520,114738,243613,907893,388447,423956,79906,851777,297195,928160,664320,106876,246248,818637,721034,375472,754501,733464,973197,543564,909187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]