SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522111 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522111 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519736,33607,195988,27137,967508,714697,258680,167725,516450,609455,1034941,630972,787178,238679,372663,661550,814896,232326,157572,849439,557580,786444,350494,91798,987418,214711,292353,82160,485599,762697,451712,650365,549691,1044456,575101,248962,732530,17196,508940,243463,91156,329814,650452,17750,900704,999627,580077,43332,193327,573698,830334,697912,829533,1011311,587063,289430,927036,283102,284498,241608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]