SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244610 LIMIT 1 [ RunTime:0.001768s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244610 [ RunTime:0.004133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175067,288387,893338,960641,1041182,100818,574729,146131,141756,808159,795752,504323,275313,273721,139349,770661,396798,456234,252797,265042,976143,327720,661628,916131,177963,901599,301831,1027488,645431,308827,568381,137846,300143,938066,648896,936364,471437,1005840,167848,67017,561096,288222,81357,912034,124072,936000,659413,416042,114910,774153,124301,689788,136636,87512,256156,682246,873916,82041,642452,844311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]