SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382763 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382763 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042344,675341,77343,982183,4980,267439,671194,1042623,56586,367907,382182,163473,898925,359798,543811,542954,278945,625183,451473,446633,847449,196307,805445,1021401,326198,926557,265347,558325,1028145,621925,51573,704046,937185,922410,880363,277755,353484,279915,895002,10716,162861,776601,517783,567711,358787,562714,609044,303342,626375,120463,472747,474977,178253,358684,1038254,176913,141821,438729,964568,774218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]