SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244511 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244511 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601449,803109,554790,278498,452299,291987,698303,150189,40876,376742,325514,851417,804742,326760,120233,262188,660934,453344,173136,76253,997467,381403,684486,725729,667909,218510,200330,749094,894781,172770,222099,594438,215497,13038,1036617,450726,37272,222994,33468,546365,217891,392887,183464,940512,572841,225065,770013,785887,914328,388175,102873,568928,874185,408888,587350,84924,481437,936958,743361,391712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]