SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43912 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43912 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401979,83579,584409,1037499,352790,711013,718463,987409,747644,547916,653782,1025449,785397,801393,246984,741672,608402,764122,158543,576268,1047046,548408,184127,447440,959510,22747,978998,471472,977872,626997,160215,170797,664897,433609,292493,535223,739423,469431,901300,258103,153397,423422,463624,360450,332344,177489,881958,55446,618628,63826,189484,280986,1010802,60276,675544,249308,985320,97445,101026,669660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]