SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511200 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511200 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260626,253211,599088,156845,29151,109100,281440,356376,527808,614768,787001,1034141,698255,424526,309802,453660,648490,472206,176284,119036,976994,900509,28400,289167,405263,967972,5821,456234,554029,175194,365466,795412,150507,854272,446904,194218,862590,851750,772027,690036,691997,79956,615008,930103,438668,837741,657184,983505,273818,393991,420104,371165,900850,1039127,43911,1015971,458660,664094,820921,290543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]