SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011216 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011216 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727950,853059,238205,358208,68669,141068,391057,741161,136992,487318,548324,779452,166262,520241,763176,362530,378328,418685,646096,74545,189339,690456,679334,928170,163751,921274,747174,856641,113388,898247,226227,714887,39324,421215,641598,346449,795874,340502,513608,916179,153741,210850,212434,955779,503337,563613,506986,796447,649224,835452,1043708,141140,825025,901887,980864,53027,684514,846010,475047,792960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]