SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 218141 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 218141 [ RunTime:0.003288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326173,62341,339492,186805,235823,363528,125647,160075,37175,195303,14008,913034,324330,782978,741485,283278,600970,923585,365603,597015,268989,365836,1010227,859329,990451,855027,192221,85467,115167,105742,670979,935698,360958,793125,628854,365008,171568,600223,453765,1003605,858565,239367,895590,446488,1024789,780698,228640,822623,242735,1027434,992399,370447,592819,848130,900480,337964,869354,693304,432311,894275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 218141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 218141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004685s ]