SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110683 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110683 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933456,261796,696015,72622,1023895,974091,605605,248593,751843,520904,952908,410913,256804,764511,319692,585423,386307,117360,335972,374937,361558,53372,1240,104195,570584,89626,641218,132500,643700,399548,82940,650533,571412,483461,975903,344841,679325,380996,739736,822838,636485,44806,1020150,154018,115900,544799,589019,242128,912343,502131,510250,64239,503063,636334,196854,141386,373319,60358,891814,1022071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]