SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584875 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584875 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185645,31576,769141,274367,499874,747290,241201,915082,175047,269475,778372,72086,931317,849837,130628,544850,534714,433055,710455,480654,71472,662251,994698,909951,776844,1030869,109559,1022400,6417,885091,406255,158455,650423,649710,24665,154352,690712,629786,233495,853998,768008,1004547,103518,28567,23250,427915,857991,208453,791855,254981,393706,716183,903407,670467,723835,443241,453655,468387,365146,25046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001264s ]